IMDB – EDA com ydata-profiling

Brought to you by YData

Dataset statistics

Number of variables	15
Number of observations	713
Missing cells	1
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	523.5 KiB
Average record size in memory	751.9 B

Variable types

Text	8
Numeric	6
Categorical	1

Alerts

`Gross` is highly overall correlated with `No_of_Votes`	High correlation
`No_of_Votes` is highly overall correlated with `IMDB_Rating` and 1 other fields	High correlation
`IMDB_Rating` is highly overall correlated with `No_of_Votes`	High correlation
`Released_Year` is highly overall correlated with `Certificate`	High correlation
`Certificate` is highly overall correlated with `Released_Year`	High correlation
`Series_Title` has unique values	Unique
`Overview` has unique values	Unique
`No_of_Votes` has unique values	Unique

Reproduction

Analysis started	2025-08-29 01:08:32.569386
Analysis finished	2025-08-29 01:08:36.388885
Duration	3.82 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

Series_Title
Text

Unique

Distinct	713
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	46.0 KiB

Length

Max length	68
Median length	41
Mean length	15.652174
Min length	2

Characters and Unicode

Total characters	11160
Distinct characters	90
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	713 ?
Unique (%)	100.0%

Sample

1st row	The Godfather
2nd row	The Dark Knight
3rd row	The Godfather: Part II
4th row	12 Angry Men
5th row	The Lord of the Rings: The Return of the King

Value	Count	Frequency (%)
the	219	10.9%
of	63	3.1%
a	21	1.0%
and	21	1.0%
in	18	0.9%
no	15	0.7%
la	15	0.7%
2	11	0.5%
de	11	0.5%
to	11	0.5%
Other values (1212)	1612	79.9%

Most occurring characters

Value	Count	Frequency (%)
	1304	11.7%
e	1055	9.5%
a	757	6.8%
o	711	6.4%
n	661	5.9%
r	620	5.6%
i	615	5.5%
t	575	5.2%
h	408	3.7%
s	405	3.6%
Other values (80)	4049	36.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	11160	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	1304	11.7%
e	1055	9.5%
a	757	6.8%
o	711	6.4%
n	661	5.9%
r	620	5.6%
i	615	5.5%
t	575	5.2%
h	408	3.7%
s	405	3.6%
Other values (80)	4049	36.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	11160	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	1304	11.7%
e	1055	9.5%
a	757	6.8%
o	711	6.4%
n	661	5.9%
r	620	5.6%
i	615	5.5%
t	575	5.2%
h	408	3.7%
s	405	3.6%
Other values (80)	4049	36.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	11160	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	1304	11.7%
e	1055	9.5%
a	757	6.8%
o	711	6.4%
n	661	5.9%
r	620	5.6%
i	615	5.5%
t	575	5.2%
h	408	3.7%
s	405	3.6%
Other values (80)	4049	36.3%

Released_Year
Real number (ℝ)

High correlation

Distinct	82
Distinct (%)	11.5%
Missing	1
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1995.7388

Minimum	1930
Maximum	2019
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	1930
5-th percentile	1958.55
Q1	1986.75
median	2001
Q3	2010
95-th percentile	2017
Maximum	2019
Range	89
Interquartile range (IQR)	23.25

Descriptive statistics

Standard deviation	18.611182
Coefficient of variation (CV)	0.0093254601
Kurtosis	0.92688061
Mean	1995.7388
Median Absolute Deviation (MAD)	11
Skewness	-1.1460661
Sum	1420966
Variance	346.3761
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2014	28	3.9%
2004	27	3.8%
2001	24	3.4%
2009	23	3.2%
2013	22	3.1%
2007	21	2.9%
2006	21	2.9%
2016	20	2.8%
2003	19	2.7%
1993	19	2.7%
Other values (72)	488	68.4%

Value	Count	Frequency (%)
1930	1	0.1%
1931	1	0.1%
1933	1	0.1%
1934	1	0.1%
1936	1	0.1%
1938	1	0.1%
1939	3	0.4%
1940	3	0.4%
1941	1	0.1%
1942	1	0.1%

Value	Count	Frequency (%)
2019	15	2.1%
2018	12	1.7%
2017	18	2.5%
2016	20	2.8%
2015	18	2.5%
2014	28	3.9%
2013	22	3.1%
2012	14	2.0%
2011	14	2.0%
2010	18	2.5%

Certificate
Categorical

High correlation

Distinct	9
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	35.4 KiB

U	183
A	173
UA	143
R	131
PG-13	38
Other values (4)	45

Length

Max length	8
Median length	1
Mean length	1.5946704
Min length	1

Characters and Unicode

Total characters	1137
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	A
2nd row	UA
3rd row	A
4th row	U
5th row	U

Common Values

Value	Count	Frequency (%)
U	183	25.7%
A	173	24.3%
UA	143	20.1%
R	131	18.4%
PG-13	38	5.3%
PG	20	2.8%
Approved	15	2.1%
G	9	1.3%
Other	1	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
u	183	25.7%
a	173	24.3%
ua	143	20.1%
r	131	18.4%
pg-13	38	5.3%
pg	20	2.8%
approved	15	2.1%
g	9	1.3%
other	1	0.1%

Most occurring characters

Value	Count	Frequency (%)
A	331	29.1%
U	326	28.7%
R	131	11.5%
G	67	5.9%
P	58	5.1%
-	38	3.3%
1	38	3.3%
3	38	3.3%
p	30	2.6%
r	16	1.4%
Other values (7)	64	5.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1137	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	331	29.1%
U	326	28.7%
R	131	11.5%
G	67	5.9%
P	58	5.1%
-	38	3.3%
1	38	3.3%
3	38	3.3%
p	30	2.6%
r	16	1.4%
Other values (7)	64	5.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1137	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	331	29.1%
U	326	28.7%
R	131	11.5%
G	67	5.9%
P	58	5.1%
-	38	3.3%
1	38	3.3%
3	38	3.3%
p	30	2.6%
r	16	1.4%
Other values (7)	64	5.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1137	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	331	29.1%
U	326	28.7%
R	131	11.5%
G	67	5.9%
P	58	5.1%
-	38	3.3%
1	38	3.3%
3	38	3.3%
p	30	2.6%
r	16	1.4%
Other values (7)	64	5.6%

Runtime
Real number (ℝ)

Distinct	118
Distinct (%)	16.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	123.69004

Minimum	72
Maximum	238
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	72
5-th percentile	90
Q1	104
median	120
Q3	136
95-th percentile	174.4
Maximum	238
Range	166
Interquartile range (IQR)	32

Descriptive statistics

Standard deviation	25.896632
Coefficient of variation (CV)	0.20936715
Kurtosis	1.3731226
Mean	123.69004
Median Absolute Deviation (MAD)	16
Skewness	1.0116596
Sum	88191
Variance	670.63553
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
130	20	2.8%
101	18	2.5%
100	17	2.4%
129	17	2.4%
102	17	2.4%
122	16	2.2%
127	15	2.1%
120	15	2.1%
113	15	2.1%
108	14	2.0%
Other values (108)	549	77.0%

Value	Count	Frequency (%)
72	1	0.1%
76	1	0.1%
78	1	0.1%
80	3	0.4%
81	3	0.4%
82	2	0.3%
83	2	0.3%
84	2	0.3%
85	3	0.4%
86	4	0.6%

Value	Count	Frequency (%)
238	1	0.1%
228	1	0.1%
224	1	0.1%
212	1	0.1%
209	1	0.1%
207	1	0.1%
202	2	0.3%
201	1	0.1%
197	2	0.3%
195	1	0.1%

Genre
Text

Distinct	172
Distinct (%)	24.1%
Missing	0
Missing (%)	0.0%
Memory size	47.8 KiB

Length

Max length	29
Median length	24
Mean length	19.453015
Min length	5

Characters and Unicode

Total characters	13870
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	64 ?
Unique (%)	9.0%

Sample

1st row	Crime, Drama
2nd row	Action, Crime, Drama
3rd row	Crime, Drama
4th row	Crime, Drama
5th row	Action, Adventure, Drama

Value	Count	Frequency (%)
drama	499	27.3%
adventure	163	8.9%
comedy	161	8.8%
crime	142	7.8%
action	140	7.7%
thriller	99	5.4%
biography	88	4.8%
romance	88	4.8%
mystery	70	3.8%
animation	63	3.4%
Other values (11)	316	17.3%

Most occurring characters

Value	Count	Frequency (%)
a	1430	10.3%
r	1320	9.5%
,	1116	8.0%
	1116	8.0%
m	1002	7.2%
e	918	6.6%
i	838	6.0%
o	637	4.6%
n	588	4.2%
t	562	4.1%
Other values (23)	4343	31.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	13870	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	1430	10.3%
r	1320	9.5%
,	1116	8.0%
	1116	8.0%
m	1002	7.2%
e	918	6.6%
i	838	6.0%
o	637	4.6%
n	588	4.2%
t	562	4.1%
Other values (23)	4343	31.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	13870	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	1430	10.3%
r	1320	9.5%
,	1116	8.0%
	1116	8.0%
m	1002	7.2%
e	918	6.6%
i	838	6.0%
o	637	4.6%
n	588	4.2%
t	562	4.1%
Other values (23)	4343	31.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	13870	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	1430	10.3%
r	1320	9.5%
,	1116	8.0%
	1116	8.0%
m	1002	7.2%
e	918	6.6%
i	838	6.0%
o	637	4.6%
n	588	4.2%
t	562	4.1%
Other values (23)	4343	31.3%

IMDB_Rating
Real number (ℝ)

High correlation

Distinct	16
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.9352034

Minimum	7.6
Maximum	9.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	7.6
5-th percentile	7.6
Q1	7.7
median	7.9
Q3	8.1
95-th percentile	8.5
Maximum	9.2
Range	1.6
Interquartile range (IQR)	0.4

Descriptive statistics

Standard deviation	0.28899865
Coefficient of variation (CV)	0.036419816
Kurtosis	1.269796
Mean	7.9352034
Median Absolute Deviation (MAD)	0.2
Skewness	1.1171782
Sum	5657.8
Variance	0.083520218
Monotonicity	Decreasing

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
7.7	121	17.0%
7.8	107	15.0%
7.6	107	15.0%
8	97	13.6%
7.9	77	10.8%
8.1	72	10.1%
8.3	33	4.6%
8.2	32	4.5%
8.4	20	2.8%
8.5	19	2.7%
Other values (6)	28	3.9%

Value	Count	Frequency (%)
7.6	107	15.0%
7.7	121	17.0%
7.8	107	15.0%
7.9	77	10.8%
8	97	13.6%
8.1	72	10.1%
8.2	32	4.5%
8.3	33	4.6%
8.4	20	2.8%
8.5	19	2.7%

Value	Count	Frequency (%)
9.2	1	0.1%
9	3	0.4%
8.9	3	0.4%
8.8	5	0.7%
8.7	5	0.7%
8.6	11	1.5%
8.5	19	2.7%
8.4	20	2.8%
8.3	33	4.6%
8.2	32	4.5%

Overview
Text

Unique

Distinct	713
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	139.9 KiB

Length

Max length	313
Median length	196
Mean length	148.75736
Min length	40

Characters and Unicode

Total characters	106064
Distinct characters	81
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	713 ?
Unique (%)	100.0%

Sample

1st row	An organized crime dynasty's aging patriarch transfers control of his clandestine empire to his reluctant son.
2nd row	When the menace known as the Joker wreaks havoc and chaos on the people of Gotham, Batman must accept one of the greatest psychological and physical tests of his ability to fight injustice.
3rd row	The early life and career of Vito Corleone in 1920s New York City is portrayed, while his son, Michael, expands and tightens his grip on the family crime syndicate.
4th row	A jury holdout attempts to prevent a miscarriage of justice by forcing his colleagues to reconsider the evidence.
5th row	Gandalf and Aragorn lead the World of Men against Sauron's army to draw his gaze from Frodo and Sam as they approach Mount Doom with the One Ring.

Value	Count	Frequency (%)
a	1144	6.3%
the	904	5.0%
to	597	3.3%
of	555	3.1%
and	505	2.8%
in	406	2.2%
his	379	2.1%
an	205	1.1%
with	180	1.0%
is	169	0.9%
Other values (4801)	13075	72.2%

Most occurring characters

Value	Count	Frequency (%)
	17406	16.4%
e	10019	9.4%
a	7094	6.7%
t	6765	6.4%
i	6376	6.0%
o	6290	5.9%
n	6151	5.8%
r	5982	5.6%
s	5751	5.4%
h	4066	3.8%
Other values (71)	30164	28.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	106064	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	17406	16.4%
e	10019	9.4%
a	7094	6.7%
t	6765	6.4%
i	6376	6.0%
o	6290	5.9%
n	6151	5.8%
r	5982	5.6%
s	5751	5.4%
h	4066	3.8%
Other values (71)	30164	28.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	106064	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	17406	16.4%
e	10019	9.4%
a	7094	6.7%
t	6765	6.4%
i	6376	6.0%
o	6290	5.9%
n	6151	5.8%
r	5982	5.6%
s	5751	5.4%
h	4066	3.8%
Other values (71)	30164	28.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	106064	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	17406	16.4%
e	10019	9.4%
a	7094	6.7%
t	6765	6.4%
i	6376	6.0%
o	6290	5.9%
n	6151	5.8%
r	5982	5.6%
s	5751	5.4%
h	4066	3.8%
Other values (71)	30164	28.4%

Meta_score
Real number (ℝ)

Distinct	63
Distinct (%)	8.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	77.154278

Minimum	28
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	28
5-th percentile	55
Q1	70
median	78
Q3	86
95-th percentile	96
Maximum	100
Range	72
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	12.409392
Coefficient of variation (CV)	0.16083868
Kurtosis	0.48825356
Mean	77.154278
Median Absolute Deviation (MAD)	8
Skewness	-0.58460256
Sum	55011
Variance	153.99302
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
76	30	4.2%
80	25	3.5%
84	25	3.5%
72	25	3.5%
90	24	3.4%
85	23	3.2%
74	23	3.2%
77	23	3.2%
73	23	3.2%
82	21	2.9%
Other values (53)	471	66.1%

Value	Count	Frequency (%)
28	1	0.1%
30	1	0.1%
33	1	0.1%
36	1	0.1%
40	1	0.1%
41	1	0.1%
44	1	0.1%
45	3	0.4%
46	1	0.1%
47	4	0.6%

Value	Count	Frequency (%)
100	11	1.5%
99	3	0.4%
98	6	0.8%
97	8	1.1%
96	12	1.7%
95	9	1.3%
94	15	2.1%
93	9	1.3%
92	11	1.5%
91	12	1.7%

Director
Text

Distinct	402
Distinct (%)	56.4%
Missing	0
Missing (%)	0.0%
Memory size	44.5 KiB

Length

Max length	32
Median length	19
Mean length	13.398317
Min length	7

Characters and Unicode

Total characters	9553
Distinct characters	63
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	263 ?
Unique (%)	36.9%

Sample

1st row	Francis Ford Coppola
2nd row	Christopher Nolan
3rd row	Francis Ford Coppola
4th row	Sidney Lumet
5th row	Peter Jackson

Value	Count	Frequency (%)
david	26	1.8%
john	24	1.6%
james	20	1.4%
martin	15	1.0%
robert	15	1.0%
richard	14	0.9%
steven	14	0.9%
spielberg	13	0.9%
lee	12	0.8%
peter	11	0.7%
Other values (633)	1316	88.9%

Most occurring characters

Value	Count	Frequency (%)
e	903	9.5%
	767	8.0%
a	729	7.6%
n	719	7.5%
r	648	6.8%
o	623	6.5%
i	585	6.1%
l	393	4.1%
s	358	3.7%
t	327	3.4%
Other values (53)	3501	36.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9553	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	903	9.5%
	767	8.0%
a	729	7.6%
n	719	7.5%
r	648	6.8%
o	623	6.5%
i	585	6.1%
l	393	4.1%
s	358	3.7%
t	327	3.4%
Other values (53)	3501	36.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9553	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	903	9.5%
	767	8.0%
a	729	7.6%
n	719	7.5%
r	648	6.8%
o	623	6.5%
i	585	6.1%
l	393	4.1%
s	358	3.7%
t	327	3.4%
Other values (53)	3501	36.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9553	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	903	9.5%
	767	8.0%
a	729	7.6%
n	719	7.5%
r	648	6.8%
o	623	6.5%
i	585	6.1%
l	393	4.1%
s	358	3.7%
t	327	3.4%
Other values (53)	3501	36.6%

Star1
Text

Distinct	471
Distinct (%)	66.1%
Missing	0
Missing (%)	0.0%
Memory size	44.2 KiB

Length

Max length	22
Median length	19
Mean length	12.927069
Min length	5

Characters and Unicode

Total characters	9217
Distinct characters	68
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	355 ?
Unique (%)	49.8%

Sample

1st row	Marlon Brando
2nd row	Christian Bale
3rd row	Al Pacino
4th row	Henry Fonda
5th row	Elijah Wood

Value	Count	Frequency (%)
tom	22	1.5%
daniel	17	1.2%
robert	13	0.9%
john	12	0.8%
hanks	12	0.8%
ethan	11	0.7%
al	11	0.7%
pacino	10	0.7%
de	10	0.7%
clint	10	0.7%
Other values (792)	1340	91.3%

Most occurring characters

Value	Count	Frequency (%)
a	821	8.9%
e	796	8.6%
	755	8.2%
n	683	7.4%
o	581	6.3%
i	577	6.3%
r	557	6.0%
l	466	5.1%
t	317	3.4%
s	313	3.4%
Other values (58)	3351	36.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9217	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	821	8.9%
e	796	8.6%
	755	8.2%
n	683	7.4%
o	581	6.3%
i	577	6.3%
r	557	6.0%
l	466	5.1%
t	317	3.4%
s	313	3.4%
Other values (58)	3351	36.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9217	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	821	8.9%
e	796	8.6%
	755	8.2%
n	683	7.4%
o	581	6.3%
i	577	6.3%
r	557	6.0%
l	466	5.1%
t	317	3.4%
s	313	3.4%
Other values (58)	3351	36.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9217	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	821	8.9%
e	796	8.6%
	755	8.2%
n	683	7.4%
o	581	6.3%
i	577	6.3%
r	557	6.0%
l	466	5.1%
t	317	3.4%
s	313	3.4%
Other values (58)	3351	36.4%

Star2
Text

Distinct	598
Distinct (%)	83.9%
Missing	0
Missing (%)	0.0%
Memory size	44.5 KiB

Length

Max length	25
Median length	22
Mean length	13.239832
Min length	5

Characters and Unicode

Total characters	9440
Distinct characters	67
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	521 ?
Unique (%)	73.1%

Sample

1st row	Al Pacino
2nd row	Heath Ledger
3rd row	Robert De Niro
4th row	Lee J. Cobb
5th row	Viggo Mortensen

Value	Count	Frequency (%)
robert	14	0.9%
john	13	0.9%
michael	10	0.7%
lee	10	0.7%
emma	10	0.7%
chris	9	0.6%
tom	8	0.5%
james	7	0.5%
george	7	0.5%
christopher	7	0.5%
Other values (1013)	1385	93.6%

Most occurring characters

Value	Count	Frequency (%)
e	918	9.7%
a	865	9.2%
	767	8.1%
n	688	7.3%
r	641	6.8%
i	552	5.8%
o	531	5.6%
l	445	4.7%
t	376	4.0%
s	319	3.4%
Other values (57)	3338	35.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9440	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	918	9.7%
a	865	9.2%
	767	8.1%
n	688	7.3%
r	641	6.8%
i	552	5.8%
o	531	5.6%
l	445	4.7%
t	376	4.0%
s	319	3.4%
Other values (57)	3338	35.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9440	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	918	9.7%
a	865	9.2%
	767	8.1%
n	688	7.3%
r	641	6.8%
i	552	5.8%
o	531	5.6%
l	445	4.7%
t	376	4.0%
s	319	3.4%
Other values (57)	3338	35.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9440	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	918	9.7%
a	865	9.2%
	767	8.1%
n	688	7.3%
r	641	6.8%
i	552	5.8%
o	531	5.6%
l	445	4.7%
t	376	4.0%
s	319	3.4%
Other values (57)	3338	35.4%

Star3
Text

Distinct	625
Distinct (%)	87.7%
Missing	0
Missing (%)	0.0%
Memory size	44.4 KiB

Length

Max length	27
Median length	21
Mean length	13.28331
Min length	5

Characters and Unicode

Total characters	9471
Distinct characters	69
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	561 ?
Unique (%)	78.7%

Sample

1st row	James Caan
2nd row	Aaron Eckhart
3rd row	Robert Duvall
4th row	Martin Balsam
5th row	Ian McKellen

Value	Count	Frequency (%)
john	17	1.2%
robert	14	0.9%
michael	11	0.7%
richard	8	0.5%
jennifer	7	0.5%
lee	7	0.5%
jack	7	0.5%
de	7	0.5%
christopher	7	0.5%
rupert	7	0.5%
Other values (1023)	1382	93.8%

Most occurring characters

Value	Count	Frequency (%)
e	868	9.2%
a	846	8.9%
	761	8.0%
n	697	7.4%
i	622	6.6%
r	610	6.4%
o	570	6.0%
l	461	4.9%
t	327	3.5%
s	309	3.3%
Other values (59)	3400	35.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9471	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	868	9.2%
a	846	8.9%
	761	8.0%
n	697	7.4%
i	622	6.6%
r	610	6.4%
o	570	6.0%
l	461	4.9%
t	327	3.5%
s	309	3.3%
Other values (59)	3400	35.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9471	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	868	9.2%
a	846	8.9%
	761	8.0%
n	697	7.4%
i	622	6.6%
r	610	6.4%
o	570	6.0%
l	461	4.9%
t	327	3.5%
s	309	3.3%
Other values (59)	3400	35.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9471	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	868	9.2%
a	846	8.9%
	761	8.0%
n	697	7.4%
i	622	6.6%
r	610	6.4%
o	570	6.0%
l	461	4.9%
t	327	3.5%
s	309	3.3%
Other values (59)	3400	35.9%

Star4
Text

Distinct	670
Distinct (%)	94.0%
Missing	0
Missing (%)	0.0%
Memory size	44.5 KiB

Length

Max length	27
Median length	23
Mean length	13.232819
Min length	4

Characters and Unicode

Total characters	9435
Distinct characters	70
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	631 ?
Unique (%)	88.5%

Sample

1st row	Diane Keaton
2nd row	Michael Caine
3rd row	Diane Keaton
4th row	John Fiedler
5th row	Orlando Bloom

Value	Count	Frequency (%)
john	17	1.1%
michael	15	1.0%
james	10	0.7%
mark	8	0.5%
richard	8	0.5%
lee	7	0.5%
bill	7	0.5%
charles	6	0.4%
jason	6	0.4%
paul	6	0.4%
Other values (1114)	1393	93.9%

Most occurring characters

Value	Count	Frequency (%)
a	872	9.2%
e	837	8.9%
	770	8.2%
n	671	7.1%
r	629	6.7%
i	622	6.6%
o	518	5.5%
l	474	5.0%
s	324	3.4%
t	297	3.1%
Other values (60)	3421	36.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9435	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	872	9.2%
e	837	8.9%
	770	8.2%
n	671	7.1%
r	629	6.7%
i	622	6.6%
o	518	5.5%
l	474	5.0%
s	324	3.4%
t	297	3.1%
Other values (60)	3421	36.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9435	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	872	9.2%
e	837	8.9%
	770	8.2%
n	671	7.1%
r	629	6.7%
i	622	6.6%
o	518	5.5%
l	474	5.0%
s	324	3.4%
t	297	3.1%
Other values (60)	3421	36.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9435	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	872	9.2%
e	837	8.9%
	770	8.2%
n	671	7.1%
r	629	6.7%
i	622	6.6%
o	518	5.5%
l	474	5.0%
s	324	3.4%
t	297	3.1%
Other values (60)	3421	36.3%

No_of_Votes
Real number (ℝ)

High correlation Unique

Distinct	713
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	353348.04

Minimum	25229
Maximum	2303232
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	25229
5-th percentile	38222.6
Q1	95826
median	236311
Q3	505918
95-th percentile	1034917.4
Maximum	2303232
Range	2278003
Interquartile range (IQR)	410092

Descriptive statistics

Standard deviation	346221.17
Coefficient of variation (CV)	0.97983044
Kurtosis	4.240262
Mean	353348.04
Median Absolute Deviation (MAD)	167040
Skewness	1.8230128
Sum	2.5193715 × 10⁸
Variance	1.198691 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1620367	1	0.1%
157498	1	0.1%
56235	1	0.1%
88511	1	0.1%
372490	1	0.1%
133351	1	0.1%
65659	1	0.1%
98611	1	0.1%
25229	1	0.1%
37445	1	0.1%
Other values (703)	703	98.6%

Value	Count	Frequency (%)
25229	1	0.1%
25938	1	0.1%
26337	1	0.1%
27007	1	0.1%
27067	1	0.1%
27071	1	0.1%
27650	1	0.1%
28003	1	0.1%
28223	1	0.1%
28825	1	0.1%

Value	Count	Frequency (%)
2303232	1	0.1%
2067042	1	0.1%
1854740	1	0.1%
1826188	1	0.1%
1809221	1	0.1%
1676426	1	0.1%
1661481	1	0.1%
1642758	1	0.1%
1620367	1	0.1%
1516346	1	0.1%

Gross
Real number (ℝ)

High correlation

Distinct	709
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78583953

Minimum	1305
Maximum	9.3666222 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.7 KiB

Quantile statistics

Minimum	1305
5-th percentile	528032.8
Q1	6153939
median	35000000
Q3	1.0251579 × 10⁸
95-th percentile	3.0354625 × 10⁸
Maximum	9.3666222 × 10⁸
Range	9.3666092 × 10⁸
Interquartile range (IQR)	96361854

Descriptive statistics

Standard deviation	1.1504328 × 10⁸
Coefficient of variation (CV)	1.4639538
Kurtosis	12.202619
Mean	78583953
Median Absolute Deviation (MAD)	31800000
Skewness	2.9227705
Sum	5.6030358 × 10¹⁰
Variance	1.3234956 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4360000	3	0.4%
9600000	2	0.3%
25000000	2	0.3%
134966411	1	0.1%
44785053	1	0.1%
435110554	1	0.1%
106260000	1	0.1%
31800000	1	0.1%
4420000	1	0.1%
193817	1	0.1%
Other values (699)	699	98.0%

Value	Count	Frequency (%)
1305	1	0.1%
3600	1	0.1%
8060	1	0.1%
10177	1	0.1%
12562	1	0.1%
14131	1	0.1%
19181	1	0.1%
25812	1	0.1%
45289	1	0.1%
55000	1	0.1%

Value	Count	Frequency (%)
936662225	1	0.1%
858373000	1	0.1%
760507625	1	0.1%
678815482	1	0.1%
659325379	1	0.1%
623279547	1	0.1%
608581744	1	0.1%
534858444	1	0.1%
532177324	1	0.1%
448139099	1	0.1%

	Certificate	Gross	IMDB_Rating	Meta_score	No_of_Votes	Released_Year	Runtime
Certificate	1.000	0.109	0.040	0.070	0.113	0.263	0.117
Gross	0.109	1.000	0.029	-0.068	0.657	0.180	0.216
IMDB_Rating	0.040	0.029	1.000	0.289	0.399	-0.151	0.211
Meta_score	0.070	-0.068	0.289	1.000	-0.012	-0.173	-0.059
No_of_Votes	0.113	0.657	0.399	-0.012	1.000	0.233	0.176
Released_Year	0.263	0.180	-0.151	-0.173	0.233	1.000	0.049
Runtime	0.117	0.216	0.211	-0.059	0.176	0.049	1.000

	Released_Year	Runtime	IMDB_Rating	Meta_score	No_of_Votes	Gross
Released_Year	1.000	-0.018	-0.179	-0.273	0.200	0.235
Runtime	-0.018	1.000	0.258	-0.006	0.213	0.169
IMDB_Rating	-0.179	0.258	1.000	0.284	0.609	0.131
Meta_score	-0.273	-0.006	0.284	1.000	0.029	-0.015
No_of_Votes	0.200	0.213	0.609	0.029	1.000	0.561
Gross	0.235	0.169	0.131	-0.015	0.561	1.000

	Released_Year	Runtime	IMDB_Rating	Meta_score	No_of_Votes	Gross
Released_Year	1.000	0.049	-0.151	-0.173	0.233	0.180
Runtime	0.049	1.000	0.211	-0.059	0.176	0.216
IMDB_Rating	-0.151	0.211	1.000	0.289	0.399	0.029
Meta_score	-0.173	-0.059	0.289	1.000	-0.012	-0.068
No_of_Votes	0.233	0.176	0.399	-0.012	1.000	0.657
Gross	0.180	0.216	0.029	-0.068	0.657	1.000

	Released_Year	Runtime	IMDB_Rating	Meta_score	No_of_Votes	Gross
Released_Year	1.000	0.034	-0.106	-0.118	0.155	0.125
Runtime	0.034	1.000	0.151	-0.041	0.119	0.148
IMDB_Rating	-0.106	0.151	1.000	0.210	0.287	0.019
Meta_score	-0.118	-0.041	0.210	1.000	-0.009	-0.046
No_of_Votes	0.155	0.119	0.287	-0.009	1.000	0.471
Gross	0.125	0.148	0.019	-0.046	0.471	1.000

	Released_Year	Certificate	Runtime	IMDB_Rating	Meta_score	No_of_Votes	Gross
Released_Year	1.000	0.514	0.290	0.229	0.422	0.176	0.000
Certificate	0.514	1.000	0.250	0.089	0.152	0.244	0.235
Runtime	0.290	0.250	1.000	0.465	0.081	0.343	0.245
IMDB_Rating	0.229	0.089	0.465	1.000	0.260	0.824	0.400
Meta_score	0.422	0.152	0.081	0.260	1.000	0.000	0.000
No_of_Votes	0.176	0.244	0.343	0.824	0.000	1.000	0.759
Gross	0.000	0.235	0.245	0.400	0.000	0.759	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	Series_Title	Released_Year	Certificate	Runtime	Genre	IMDB_Rating	Overview	Meta_score	Director	Star1	Star2	Star3	Star4	No_of_Votes	Gross
0	The Godfather	1972.0	A	175	Crime, Drama	9.2	An organized crime dynasty's aging patriarch transfers control of his clandestine empire to his reluctant son.	100.0	Francis Ford Coppola	Marlon Brando	Al Pacino	James Caan	Diane Keaton	1620367	134966411
1	The Dark Knight	2008.0	UA	152	Action, Crime, Drama	9.0	When the menace known as the Joker wreaks havoc and chaos on the people of Gotham, Batman must accept one of the greatest psychological and physical tests of his ability to fight injustice.	84.0	Christopher Nolan	Christian Bale	Heath Ledger	Aaron Eckhart	Michael Caine	2303232	534858444
2	The Godfather: Part II	1974.0	A	202	Crime, Drama	9.0	The early life and career of Vito Corleone in 1920s New York City is portrayed, while his son, Michael, expands and tightens his grip on the family crime syndicate.	90.0	Francis Ford Coppola	Al Pacino	Robert De Niro	Robert Duvall	Diane Keaton	1129952	57300000
3	12 Angry Men	1957.0	U	96	Crime, Drama	9.0	A jury holdout attempts to prevent a miscarriage of justice by forcing his colleagues to reconsider the evidence.	96.0	Sidney Lumet	Henry Fonda	Lee J. Cobb	Martin Balsam	John Fiedler	689845	4360000
4	The Lord of the Rings: The Return of the King	2003.0	U	201	Action, Adventure, Drama	8.9	Gandalf and Aragorn lead the World of Men against Sauron's army to draw his gaze from Frodo and Sam as they approach Mount Doom with the One Ring.	94.0	Peter Jackson	Elijah Wood	Viggo Mortensen	Ian McKellen	Orlando Bloom	1642758	377845905
5	Pulp Fiction	1994.0	A	154	Crime, Drama	8.9	The lives of two mob hitmen, a boxer, a gangster and his wife, and a pair of diner bandits intertwine in four tales of violence and redemption.	94.0	Quentin Tarantino	John Travolta	Uma Thurman	Samuel L. Jackson	Bruce Willis	1826188	107928762
6	Schindler's List	1993.0	A	195	Biography, Drama, History	8.9	In German-occupied Poland during World War II, industrialist Oskar Schindler gradually becomes concerned for his Jewish workforce after witnessing their persecution by the Nazis.	94.0	Steven Spielberg	Liam Neeson	Ralph Fiennes	Ben Kingsley	Caroline Goodall	1213505	96898818
7	Inception	2010.0	UA	148	Action, Adventure, Sci-Fi	8.8	A thief who steals corporate secrets through the use of dream-sharing technology is given the inverse task of planting an idea into the mind of a C.E.O.	74.0	Christopher Nolan	Leonardo DiCaprio	Joseph Gordon-Levitt	Elliot Page	Ken Watanabe	2067042	292576195
8	Fight Club	1999.0	A	139	Drama	8.8	An insomniac office worker and a devil-may-care soapmaker form an underground fight club that evolves into something much, much more.	66.0	David Fincher	Brad Pitt	Edward Norton	Meat Loaf	Zach Grenier	1854740	37030102
9	The Lord of the Rings: The Fellowship of the Ring	2001.0	U	178	Action, Adventure, Drama	8.8	A meek Hobbit from the Shire and eight companions set out on a journey to destroy the powerful One Ring and save Middle-earth from the Dark Lord Sauron.	92.0	Peter Jackson	Elijah Wood	Ian McKellen	Orlando Bloom	Sean Bean	1661481	315544750

	Series_Title	Released_Year	Certificate	Runtime	Genre	IMDB_Rating	Overview	Meta_score	Director	Star1	Star2	Star3	Star4	No_of_Votes	Gross
703	The Muppet Movie	1979.0	U	95	Adventure, Comedy, Family	7.6	Kermit and his newfound friends trek across America to find success in Hollywood, but a frog legs merchant is after Kermit.	74.0	James Frawley	Jim Henson	Frank Oz	Jerry Nelson	Richard Hunt	32802	76657000
704	Escape from Alcatraz	1979.0	A	112	Action, Biography, Crime	7.6	Alcatraz is the most secure prison of its time. It is believed that no one can ever escape from it, until three daring men make a possible successful attempt at escaping from one of the most infamous prisons in the world.	76.0	Don Siegel	Clint Eastwood	Patrick McGoohan	Roberts Blossom	Jack Thibeau	121731	43000000
705	Midnight Express	1978.0	A	121	Biography, Crime, Drama	7.6	Billy Hayes, an American college student, is caught smuggling drugs out of Turkey and thrown into prison.	59.0	Alan Parker	Brad Davis	Irene Miracle	Bo Hopkins	Paolo Bonacelli	73662	35000000
706	Close Encounters of the Third Kind	1977.0	U	138	Drama, Sci-Fi	7.6	Roy Neary, an electric lineman, watches how his quiet and ordinary daily life turns upside down after a close encounter with a UFO.	90.0	Steven Spielberg	Richard Dreyfuss	François Truffaut	Teri Garr	Melinda Dillon	184966	132088635
707	The Long Goodbye	1973.0	A	112	Comedy, Crime, Drama	7.6	Private investigator Philip Marlowe helps a friend out of a jam, but in doing so gets implicated in his wife's murder.	87.0	Robert Altman	Elliott Gould	Nina van Pallandt	Sterling Hayden	Mark Rydell	26337	959000
708	Giù la testa	1971.0	PG	157	Drama, War, Western	7.6	A low-life bandit and an I.R.A. explosives expert rebel against the government and become heroes of the Mexican Revolution.	77.0	Sergio Leone	Rod Steiger	James Coburn	Romolo Valli	Maria Monti	30144	696690
709	Kelly's Heroes	1970.0	PG	144	Adventure, Comedy, War	7.6	A group of U.S. soldiers sneaks across enemy lines to get their hands on a secret stash of Nazi treasure.	50.0	Brian G. Hutton	Clint Eastwood	Telly Savalas	Don Rickles	Carroll O'Connor	45338	1378435
710	The Jungle Book	1967.0	U	78	Animation, Adventure, Family	7.6	Bagheera the Panther and Baloo the Bear have a difficult time trying to convince a boy to leave the jungle for human civilization.	65.0	Wolfgang Reitherman	Phil Harris	Sebastian Cabot	Louis Prima	Bruce Reitherman	166409	141843612
711	A Hard Day's Night	1964.0	U	87	Comedy, Music, Musical	7.6	Over two "typical" days in the life of The Beatles, the boys struggle to keep themselves and Sir Paul McCartney's mischievous grandfather in check while preparing for a live television performance.	96.0	Richard Lester	John Lennon	Paul McCartney	George Harrison	Ringo Starr	40351	13780024
712	From Here to Eternity	1953.0	Approved	118	Drama, Romance, War	7.6	In Hawaii in 1941, a private is cruelly punished for not boxing on his unit's team, while his captain's wife and second-in-command are falling in love.	85.0	Fred Zinnemann	Burt Lancaster	Montgomery Clift	Deborah Kerr	Donna Reed	43374	30500000

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts